package com.sec.etech.employeesync.mapper;

import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sec.etech.employeesync.entity.OrgEmployeeZLevelJobRelation;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author : 齐马的作品
 * @version : 1.0
 * @date : 2024/8/26 上午9:31
 * @description:
 */
public interface OrgEmployeeZLevelJobRelationMapper extends BaseMapper<OrgEmployeeZLevelJobRelation> {

    @Select("SELECT t.code_ code, r.confirm\n" +
            "FROM org_employee_z_level_job_relation r\n" +
            "         LEFT JOIN org_employee_z_tertiary_level_job t ON r.tertiary_level_job_id = t.tertiary_level_job_id")
    List<JSONObject> queryAllConfirm();
}
